/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50624
 Source Host           : localhost
 Source Database       : stylist

 Target Server Type    : MySQL
 Target Server Version : 50624
 File Encoding         : utf-8

 Date: 11/06/2015 01:05:04 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `datasource` varchar(256) DEFAULT NULL,
  `source_category` varchar(256) DEFAULT NULL,
  `source_category_column` varchar(256) DEFAULT NULL,
  `styllofical_sub_category` varchar(256) DEFAULT NULL,
  `styllofical_category` varchar(256) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1918 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `category`
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES ('linshare', 'Accessories', 'AN INVITATION~~Acces', 'ACCESSORIES', 'ACCESSORIES', '1589', null, null), ('linshare', 'Accessories', 'CC~~Accessories', 'ACCESSORIES', 'ACCESSORIES', '1590', null, null), ('linshare', 'Accessories', 'Gifts for Him~~New C', 'ACCESSORIES', 'ACCESSORIES', '1591', null, null), ('linshare', 'Accessories', 'HOLIDAY SHOP~~Access', 'ACCESSORIES', 'ACCESSORIES', '1592', null, null), ('linshare', 'Accessories', 'New Collection~~Race', 'ACCESSORIES', 'ACCESSORIES', '1593', null, null), ('linshare', 'Accessories', 'New Collection~~Vale', 'ACCESSORIES', 'ACCESSORIES', '1594', null, null), ('linshare', 'Accessories', 'Outlet Accessories~~', 'ACCESSORIES', 'ACCESSORIES', '1595', null, null), ('linshare', 'Accessories', 'parfum', 'ACCESSORIES', 'ACCESSORIES', '1596', null, null), ('linshare', 'Accessories', 'Party~~Gifts for Him', 'ACCESSORIES', 'ACCESSORIES', '1597', null, null), ('linshare', 'Accessories', 'Sale~~CC~~Accessorie', 'ACCESSORIES', 'ACCESSORIES', '1598', null, null), ('linshare', 'Accessories', 'Sale~~Women~~Accesso', 'ACCESSORIES', 'ACCESSORIES', '1599', null, null), ('linshare', 'Accessories', 'Sale~~Women~~Viyella', 'ACCESSORIES', 'ACCESSORIES', '1600', null, null), ('linshare', 'Accessories', 'Valentines Gifts For', 'ACCESSORIES', 'ACCESSORIES', '1601', null, null), ('linshare', 'Accessories', 'Women~~Accessories', 'ACCESSORIES', 'ACCESSORIES', '1602', null, null), ('linshare', 'Accessories', 'Women~~Viyella Women', 'ACCESSORIES', 'ACCESSORIES', '1603', null, null), ('linshare', 'All accessories', 'UNIQLO UNIQLO~~WOMEN', 'ACCESSORIES', 'ACCESSORIES', '1604', null, null), ('linshare', 'All knitwear', 'UNIQLO UNIQLO~~WOMEN', 'KNITWEAR', 'CLOTHING', '1605', null, null), ('linshare', 'All outerwear', 'UNIQLO UNIQLO~~WOMEN', 'COATS & JACKETS', 'CLOTHING', '1606', null, null), ('linshare', 'Apparel', 'Casualwear Dresses', 'DRESSES', 'CLOTHING', '1607', null, null), ('linshare', 'Apparel', 'Casualwear Jackets', 'JACKETS', 'CLOTHING', '1608', null, null), ('linshare', 'Apparel', 'Casualwear Shirts', 'SHIRTS', 'CLOTHING', '1609', null, null), ('linshare', 'Apparel', 'Casualwear Skirts', 'SKIRTS', 'CLOTHING', '1610', null, null), ('linshare', 'Apparel', 'Casualwear Tops', 'TOPS', 'CLOTHING', '1611', null, null), ('linshare', 'Apparel', 'Casualwear Vests', 'TOPS', 'CLOTHING', '1612', null, null), ('linshare', 'Apparel', 'Concession Earrings', 'ACCESSORIES', 'ACCESSORIES', '1613', null, null), ('linshare', 'Apparel', 'Concession Neckwear', 'ACCESSORIES', 'ACCESSORIES', '1614', null, null), ('linshare', 'Apparel', 'Concession Rings', 'ACCESSORIES', 'ACCESSORIES', '1615', null, null), ('linshare', 'Apparel', 'Concession Watches', 'ACCESSORIES', 'ACCESSORIES', '1616', null, null), ('linshare', 'Apparel', 'Concession Wristwear', 'ACCESSORIES', 'ACCESSORIES', '1617', null, null), ('linshare', 'Apparel', 'Fashion Belts', 'BELTS', 'ACCESSORIES', '1618', null, null), ('linshare', 'Apparel', 'Jersey Cardigans', 'KNITWEAR', 'CLOTHING', '1619', null, null), ('linshare', 'Apparel', 'Jersey Dresses', 'DRESSES', 'CLOTHING', '1620', null, null), ('linshare', 'Apparel', 'Jersey Jackets', 'COATS & JACKETS', 'CLOTHING', '1621', null, null), ('linshare', 'Apparel', 'Jersey Skirts', 'SKIRTS', 'CLOTHING', '1622', null, null), ('linshare', 'Apparel', 'Jersey Vests', 'TOPS', 'CLOTHING', '1623', null, null), ('linshare', 'Apparel', 'Jesrsey Tunics', 'TOPS', 'CLOTHING', '1624', null, null), ('linshare', 'Apparel', 'Knitwear Cardigans', 'KNITWEAR', 'CLOTHING', '1625', null, null), ('linshare', 'Apparel', 'Knitwear Dresses', 'DRESSES', 'CLOTHING', '1626', null, null), ('linshare', 'Apparel', 'Knitwear Skirts', 'SKIRTS', 'CLOTHING', '1627', null, null), ('linshare', 'Apparel', 'Knitwear Tops', 'TOPS', 'CLOTHING', '1628', null, null), ('linshare', 'Apparel', 'Leather Bags', 'HANDBAGS', 'ACCESSORIES', '1629', null, null), ('linshare', 'Apparel', 'Leather Jackets', 'COATS & JACKETS', 'CLOTHING', '1630', null, null), ('linshare', 'Apparel', 'Leather Skirts', 'SKIRTS', 'CLOTHING', '1631', null, null), ('linshare', 'Apparel', 'Leather Tops', 'TOPS', 'CLOTHING', '1632', null, null), ('linshare', 'Apparel', 'Lightweight Scarves', 'SCARVES', 'ACCESSORIES', '1633', null, null), ('linshare', 'Apparel', 'Main Range Boots', 'BOOTS', 'SHOES', '1634', null, null), ('linshare', 'Apparel', 'Main Range Sandals', 'SANDALS', 'SHOES', '1635', null, null), ('linshare', 'Apparel', 'Main Range Shoes', 'SHOES', 'SHOES', '1636', null, null), ('linshare', 'Apparel', 'Main Range Wedges', 'SANDALS', 'SHOES', '1637', null, null), ('linshare', 'Bags', 'How to: Go from Day ', 'HANDBAGS', 'ACCESSORIES', '1638', null, null), ('linshare', 'bags', 'New Collection~~Shou', 'HANDBAGS', 'ACCESSORIES', '1639', null, null), ('linshare', 'bags', 'New Collection~~Tote', 'HANDBAGS', 'ACCESSORIES', '1640', null, null), ('linshare', 'bags', 'New Collection~~Vale', 'HANDBAGS', 'ACCESSORIES', '1641', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~A', 'HANDBAGS', 'ACCESSORIES', '1642', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~C', 'HANDBAGS', 'ACCESSORIES', '1643', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~G', 'HANDBAGS', 'ACCESSORIES', '1644', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~H', 'HANDBAGS', 'ACCESSORIES', '1645', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~M', 'HANDBAGS', 'ACCESSORIES', '1646', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~N', 'HANDBAGS', 'ACCESSORIES', '1647', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~P', 'HANDBAGS', 'ACCESSORIES', '1648', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~S', 'HANDBAGS', 'ACCESSORIES', '1649', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~T', 'HANDBAGS', 'ACCESSORIES', '1650', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~V', 'HANDBAGS', 'ACCESSORIES', '1651', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~W', 'HANDBAGS', 'ACCESSORIES', '1652', null, null), ('linshare', 'Bags', 'Outlet Bags~~bags~~Y', 'HANDBAGS', 'ACCESSORIES', '1653', null, null), ('linshare', 'Bags', 'Outlet Bags~~How to:', 'HANDBAGS', 'ACCESSORIES', '1654', null, null), ('linshare', 'Belts', 'Outlet Accessories', 'BELTS', 'ACCESSORIES', '1655', null, null), ('linshare', 'Belts', 'Outlet Accessories~~', 'BELTS', 'ACCESSORIES', '1656', null, null), ('linshare', 'Belts', 'UNIQLO UNIQLO~~WOMEN', 'BELTS', 'ACCESSORIES', '1657', null, null), ('linshare', 'Blazers', 'AN INVITATION~~Suits', 'BLAZERS', 'CLOTHING', '1658', null, null), ('linshare', 'Blazers', 'New Collection~~LIGH', 'BLAZERS', 'CLOTHING', '1659', null, null), ('linshare', 'Blazers', 'Outlet Suits & Tailo', 'BLAZERS', 'CLOTHING', '1660', null, null), ('linshare', 'Blazers', 'Suits & Tailoring~~B', 'BLAZERS', 'CLOTHING', '1661', null, null), ('linshare', 'Casual Jackets', 'Coats & Jackets~~Bes', 'COATS & JACKETS', 'CLOTHING', '1662', null, null), ('linshare', 'Casual Jackets', 'Coats & Jackets~~New', 'COATS & JACKETS', 'CLOTHING', '1663', null, null), ('linshare', 'Casual Jackets', 'Outlet Coats & Jacke', 'COATS & JACKETS', 'CLOTHING', '1664', null, null), ('linshare', 'Casual Jackets', 'Outlet Coats and Jac', 'COATS & JACKETS', 'CLOTHING', '1665', null, null), ('linshare', 'Casual shirts', 'AN INVITATION~~Shirt', 'SHIRTS', 'CLOTHING', '1666', null, null), ('linshare', 'Casual shirts', 'Outlet Shirts', 'SHIRTS', 'CLOTHING', '1667', null, null), ('linshare', 'Casual shirts', 'Outlet Shirts~~a sty', 'SHIRTS', 'CLOTHING', '1668', null, null), ('linshare', 'Casual shirts', 'Outlet Shirts~~Casua', 'SHIRTS', 'CLOTHING', '1669', null, null), ('linshare', 'Casual shirts', 'Outlet Shirts~~Shirt', 'SHIRTS', 'CLOTHING', '1670', null, null), ('linshare', 'Casual shirts', 'Shirts~~New Collecti', 'SHIRTS', 'CLOTHING', '1671', null, null), ('linshare', 'Casual Skirts', 'Outlet Skirts~~How t', 'SKIRTS', 'CLOTHING', '1672', null, null), ('linshare', 'Casual Skirts', 'Outlet Skirts~~Outle', 'SKIRTS', 'CLOTHING', '1673', null, null), ('linshare', 'Casual Skirts', 'Outlet Skirts~~Skirt', 'SKIRTS', 'CLOTHING', '1674', null, null), ('linshare', 'Casual Skirts', 'Skirts~~New Collecti', 'SKIRTS', 'CLOTHING', '1675', null, null), ('linshare', 'Casual Trousers', 'Outlet Trousers~~How', 'TROUSERS', 'CLOTHING', '1676', null, null), ('linshare', 'Casual Trousers', 'Outlet Trousers~~Out', 'TROUSERS', 'CLOTHING', '1677', null, null), ('linshare', 'Casual Trousers', 'Outlet Trousers~~Tai', 'TROUSERS', 'CLOTHING', '1678', null, null), ('linshare', 'Casual Trousers', 'Outlet Trousers~~Tro', 'TROUSERS', 'CLOTHING', '1679', null, null), ('linshare', 'Casual Trousers', 'Trousers~~Black Magi', 'TROUSERS', 'CLOTHING', '1680', null, null), ('linshare', 'Casual Trousers', 'Trousers~~New Collec', 'TROUSERS', 'CLOTHING', '1681', null, null), ('linshare', 'Clothing', 'Sale~~Women~~Clothin', 'ALL CLOTHING', 'CLOTHING', '1682', null, null), ('linshare', 'Clothing', 'Women~~Clothing', 'ALL CLOTHING', 'CLOTHING', '1683', null, null), ('linshare', 'Coats', 'Coats & Jackets~~New', 'COATS & JACKETS', 'CLOTHING', '1684', null, null), ('linshare', 'Coats', 'Outlet Coats and Jac', 'COATS & JACKETS', 'CLOTHING', '1685', null, null), ('linshare', 'Coats and Outerwear', 'Sale~~Women~~Coats a', 'COATS & JACKETS', 'CLOTHING', '1686', null, null), ('linshare', 'Coats and Outerwear', 'Women~~Coats and Out', 'COATS & JACKETS', 'CLOTHING', '1687', null, null), ('linshare', 'Dresses', 'A Spotlight Blue~~We', 'DRESSES', 'CLOTHING', '1688', null, null), ('linshare', 'Dresses', 'New Collection~~A Sp', 'DRESSES', 'CLOTHING', '1689', null, null), ('linshare', 'Dresses', 'New Collection~~Body', 'DRESSES', 'CLOTHING', '1690', null, null), ('linshare', 'Dresses', 'New Collection~~Fit ', 'DRESSES', 'CLOTHING', '1691', null, null), ('linshare', 'Dresses', 'New Collection~~How ', 'DRESSES', 'CLOTHING', '1692', null, null), ('linshare', 'Dresses', 'New Collection~~Maxi', 'DRESSES', 'CLOTHING', '1693', null, null), ('linshare', 'Dresses', 'New Collection~~Non-', 'DRESSES', 'CLOTHING', '1694', null, null), ('linshare', 'Dresses', 'New Collection~~Shif', 'DRESSES', 'CLOTHING', '1695', null, null), ('linshare', 'Dresses', 'Outlet Dresses', 'DRESSES', 'CLOTHING', '1696', null, null), ('linshare', 'Dresses', 'Outlet Dresses~~Dres', 'DRESSES', 'CLOTHING', '1697', null, null), ('linshare', 'Dresses', 'Outlet Dresses~~Fit ', 'DRESSES', 'CLOTHING', '1698', null, null), ('linshare', 'Dresses', 'Outlet Dresses~~How ', 'DRESSES', 'CLOTHING', '1699', null, null), ('linshare', 'Dresses', 'Outlet Dresses~~Midn', 'DRESSES', 'CLOTHING', '1700', null, null), ('linshare', 'Dresses', 'Outlet Dresses~~Outl', 'DRESSES', 'CLOTHING', '1701', null, null), ('linshare', 'Dresses', 'Sale~~Women~~Dresses', 'DRESSES', 'CLOTHING', '1702', null, null), ('linshare', 'Dresses', 'Suiting~~New Collect', 'DRESSES', 'CLOTHING', '1703', null, null), ('linshare', 'Dresses', 'UNIQLO UNIQLO~~WOMEN', 'DRESSES', 'CLOTHING', '1704', null, null), ('linshare', 'Dresses', 'Women~~Dresses', 'DRESSES', 'CLOTHING', '1705', null, null), ('linshare', 'Formal Jackets', 'Coats & Jackets~~Sui', 'COATS & JACKETS', 'CLOTHING', '1706', null, null), ('linshare', 'Formal Jackets', 'Outlet Coats and Jac', 'COATS & JACKETS', 'CLOTHING', '1707', null, null), ('linshare', 'Formal Jackets', 'Outlet Suiting~~Coat', 'COATS & JACKETS', 'CLOTHING', '1708', null, null), ('linshare', 'Formal Jackets', 'Outlet Suiting~~Suit', 'COATS & JACKETS', 'CLOTHING', '1709', null, null), ('linshare', 'Formal shirts', 'AN INVITATION~~Shirt', 'SHIRTS', 'CLOTHING', '1710', null, null), ('linshare', 'Formal shirts', 'Outlet Shirts', 'SHIRTS', 'CLOTHING', '1711', null, null), ('linshare', 'Formal shirts', 'Outlet Shirts~~AN IN', 'SHIRTS', 'CLOTHING', '1712', null, null), ('linshare', 'Formal shirts', 'Outlet Shirts~~Shirt', 'SHIRTS', 'CLOTHING', '1713', null, null), ('linshare', 'Formal shirts', 'Shirts~~New Collecti', 'SHIRTS', 'CLOTHING', '1714', null, null), ('linshare', 'Formal Skirts', 'Outlet Skirts~~Outle', 'SKIRTS', 'CLOTHING', '1715', null, null), ('linshare', 'Formal Skirts', 'Skirts~~Suiting~~New', 'SKIRTS', 'CLOTHING', '1716', null, null), ('linshare', 'Formal Trousers', 'Outlet Suits & Tailo', 'TROUSERS', 'CLOTHING', '1717', null, null), ('linshare', 'Formal Trousers', 'Outlet Trousers~~Out', 'TROUSERS', 'CLOTHING', '1718', null, null), ('linshare', 'Formal Trousers', 'Suiting~~Straight an', 'TROUSERS', 'CLOTHING', '1719', null, null), ('linshare', 'Formal Trousers', 'Suits & Tailoring~~N', 'TROUSERS', 'CLOTHING', '1720', null, null), ('linshare', 'Formal Trousers', 'Suits & Tailoring~~T', 'TROUSERS', 'CLOTHING', '1721', null, null), ('linshare', 'Formal Trousers', 'Trousers~~New Collec', 'TROUSERS', 'CLOTHING', '1722', null, null), ('linshare', 'Formal Trousers', 'Trousers~~Suiting~~N', 'TROUSERS', 'CLOTHING', '1723', null, null), ('linshare', 'Handbags', 'Bucket Bags', 'HANDBAGS', 'ACCESSORIES', '1724', null, null), ('linshare', 'Handbags', 'Crossbody Bags', 'HANDBAGS', 'ACCESSORIES', '1725', null, null), ('linshare', 'Handbags', 'Hobos', 'HANDBAGS', 'ACCESSORIES', '1726', null, null), ('linshare', 'Handbags', 'New and Popular~~New', 'HANDBAGS', 'ACCESSORIES', '1727', null, null), ('linshare', 'Handbags', 'New Arrivals', 'HANDBAGS', 'ACCESSORIES', '1728', null, null), ('linshare', 'Handbags', 'Shoulder Bags', 'HANDBAGS', 'ACCESSORIES', '1729', null, null), ('linshare', 'Handbags', 'Top Handles and Satc', 'HANDBAGS', 'ACCESSORIES', '1730', null, null), ('linshare', 'Handbags', 'Totes', 'HANDBAGS', 'ACCESSORIES', '1731', null, null), ('linshare', 'Jackets', 'Sale~~Women~~Jackets', 'COATS & JACKETS', 'CLOTHING', '1732', null, null), ('linshare', 'Jackets', 'Women~~Jackets', 'COATS & JACKETS', 'CLOTHING', '1733', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Essenti', 'TOPS', 'CLOTHING', '1734', null, null), ('linshare', 'Jersey', 'Outlet Tops~~fashion', 'TOPS', 'CLOTHING', '1735', null, null), ('linshare', 'Jersey', 'Outlet Tops~~How to:', 'TOPS', 'CLOTHING', '1736', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~3', 'TOPS', 'CLOTHING', '1737', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~7', 'TOPS', 'CLOTHING', '1738', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~A', 'TOPS', 'CLOTHING', '1739', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~B', 'TOPS', 'CLOTHING', '1740', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~C', 'TOPS', 'CLOTHING', '1741', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~E', 'TOPS', 'CLOTHING', '1742', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~H', 'TOPS', 'CLOTHING', '1743', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~K', 'TOPS', 'CLOTHING', '1744', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~L', 'TOPS', 'CLOTHING', '1745', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~M', 'TOPS', 'CLOTHING', '1746', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~T', 'TOPS', 'CLOTHING', '1747', null, null), ('linshare', 'Jersey', 'Outlet Tops~~Tops~~V', 'TOPS', 'CLOTHING', '1748', null, null), ('linshare', 'Jersey', 'Tops~~New Collection', 'TOPS', 'CLOTHING', '1749', null, null), ('linshare', 'Jewelry & Watches', 'Fashion Jewelry', 'JEWELLERY', 'ACCESSORIES', '1750', null, null), ('linshare', 'Jewelry & Watches', 'Fine Jewelry - Brace', 'JEWELLERY', 'ACCESSORIES', '1751', null, null), ('linshare', 'Jewelry & Watches', 'Fine Jewelry - Earri', 'JEWELLERY', 'ACCESSORIES', '1752', null, null), ('linshare', 'Jewelry & Watches', 'Fine Jewelry - Neckl', 'JEWELLERY', 'ACCESSORIES', '1753', null, null), ('linshare', 'Jewelry & Watches', 'Fine Jewelry - Rings', 'JEWELLERY', 'ACCESSORIES', '1754', null, null), ('linshare', 'Jewelry & Watches', 'Watches - Watches', 'JEWELLERY', 'ACCESSORIES', '1755', null, null), ('linshare', 'Jewelry and Accessor', 'Accessories~~Belts~~', 'BELTS', 'ACCESSORIES', '1756', null, null), ('linshare', 'Jewelry and Accessor', 'Accessories~~Scarves', 'SCARVES', 'ACCESSORIES', '1757', null, null), ('linshare', 'Jewelry and Accessor', 'Fine Jewelry', 'JEWELLERY', 'ACCESSORIES', '1758', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Bracelets', 'JEWELLERY', 'ACCESSORIES', '1759', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Brooches', 'JEWELLERY', 'ACCESSORIES', '1760', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Earrings', 'JEWELLERY', 'ACCESSORIES', '1761', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Fine', 'JEWELLERY', 'ACCESSORIES', '1762', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Jewelry Sto', 'JEWELLERY', 'ACCESSORIES', '1763', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Necklaces', 'JEWELLERY', 'ACCESSORIES', '1764', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Rings~~Gold', 'JEWELLERY', 'ACCESSORIES', '1765', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Rings~~Silv', 'JEWELLERY', 'ACCESSORIES', '1766', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Rings~~Stac', 'JEWELLERY', 'ACCESSORIES', '1767', null, null), ('linshare', 'Jewelry and Accessor', 'Jewelry~~Rings~~Stat', 'JEWELLERY', 'ACCESSORIES', '1768', null, null), ('linshare', 'Jewelry and Accessor', 'Watches~~For Her~~Fi', 'JEWELLERY', 'ACCESSORIES', '1769', null, null), ('linshare', 'Jewelry and Accessor', 'Watches~~For Her~~Wa', 'JEWELLERY', 'ACCESSORIES', '1770', null, null), ('linshare', 'Jumpers and Cardigan', 'Sale~~Women~~Jumpers', 'KNITWEAR', 'CLOTHING', '1771', null, null), ('linshare', 'Jumpers and Cardigan', 'Women~~Jumpers and C', 'KNITWEAR', 'CLOTHING', '1772', null, null), ('linshare', 'Knitwear', 'AN INVITATION~~Tops~', 'KNITWEAR', 'CLOTHING', '1773', null, null), ('linshare', 'Knitwear', 'Black Magic~~New Col', 'KNITWEAR', 'CLOTHING', '1774', null, null), ('linshare', 'Knitwear', 'Men~~Clothing~~Knitw', 'KNITWEAR', 'CLOTHING', '1775', null, null), ('linshare', 'Knitwear', 'New Collection~~Crew', 'KNITWEAR', 'CLOTHING', '1776', null, null), ('linshare', 'Knitwear', 'New Collection~~Fine', 'KNITWEAR', 'CLOTHING', '1777', null, null), ('linshare', 'Knitwear', 'New Collection~~V-Ne', 'KNITWEAR', 'CLOTHING', '1778', null, null), ('linshare', 'Knitwear', 'New Collection~~Vale', 'KNITWEAR', 'CLOTHING', '1779', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear', 'KNITWEAR', 'CLOTHING', '1780', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~AN ', 'KNITWEAR', 'CLOTHING', '1781', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~AUT', 'KNITWEAR', 'CLOTHING', '1782', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~Cas', 'KNITWEAR', 'CLOTHING', '1783', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~Chu', 'KNITWEAR', 'CLOTHING', '1784', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~Cre', 'KNITWEAR', 'CLOTHING', '1785', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~fas', 'KNITWEAR', 'CLOTHING', '1786', null, null), ('linshare', 'Knitwear', 'Outlet Knitwear~~Kni', 'KNITWEAR', 'CLOTHING', '1787', null, null), ('linshare', 'Petite Coats and Out', 'Petite~~Petite Coats', 'COATS & JACKETS', 'CLOTHING', '1788', null, null), ('linshare', 'Petite Coats and Out', 'Sale~~Petite~~Petite', 'COATS & JACKETS', 'CLOTHING', '1789', null, null), ('linshare', 'Petite Dresses', 'Petite~~Petite Dress', 'DRESSES', 'CLOTHING', '1790', null, null), ('linshare', 'Petite Dresses', 'Sale~~Petite~~Petite', 'DRESSES', 'CLOTHING', '1791', null, null), ('linshare', 'Petite Jackets', 'Petite~~Petite Jacke', 'COATS & JACKETS', 'CLOTHING', '1792', null, null), ('linshare', 'Petite Jackets', 'Sale~~Petite~~Petite', 'COATS & JACKETS', 'CLOTHING', '1793', null, null), ('linshare', 'Petite Jumpers and C', 'Petite~~Petite Jumpe', 'KNITWEAR', 'CLOTHING', '1794', null, null), ('linshare', 'Petite Jumpers and C', 'Sale~~Petite~~Petite', 'KNITWEAR', 'CLOTHING', '1795', null, null), ('linshare', 'Petite Skirts', 'Petite~~Petite Skirt', 'SKIRTS', 'CLOTHING', '1796', null, null), ('linshare', 'Petite Skirts', 'Sale~~Petite~~Petite', 'SKIRTS', 'CLOTHING', '1797', null, null), ('linshare', 'Petite Tops and T-Sh', 'Petite~~Petite Tops ', 'TOPS', 'CLOTHING', '1798', null, null), ('linshare', 'Petite Tops and T-Sh', 'Sale~~Petite~~Petite', 'TOPS', 'CLOTHING', '1799', null, null), ('linshare', 'Petite Trousers and ', 'Petite~~Petite Trous', 'TROUSERS', 'CLOTHING', '1800', null, null), ('linshare', 'Petite Trousers and ', 'Sale~~Petite~~Petite', 'TROUSERS', 'CLOTHING', '1801', null, null), ('linshare', 'Sale', 'ankle boot', 'BOOTS', 'SHOES', '1802', null, null), ('linshare', 'Sale', 'cashmere', 'KNITWEAR', 'CLOTHING', '1803', null, null), ('linshare', 'Sale', 'high heel', 'SHOES', 'SHOES', '1804', null, null), ('linshare', 'Sale', 'Jumpers', 'KNITWEAR', 'CLOTHING', '1805', null, null), ('linshare', 'Sale', 'knee-length', 'BOOTS', 'SHOES', '1806', null, null), ('linshare', 'Sale', 'mid heel', 'SHOES', 'SHOES', '1807', null, null), ('linshare', 'Sale', 'mini', 'SHOES', 'SHOES', '1808', null, null), ('linshare', 'Scarves & Stoles', 'UNIQLO UNIQLO~~WOMEN', 'SCARVES', 'ACCESSORIES', '1809', null, null), ('linshare', 'Shirt', 'Womens', 'SHIRTS', 'CLOTHING', '1810', null, null), ('linshare', 'Shirts & Blouses', 'UNIQLO UNIQLO~~WOMEN', 'SHIRTS', 'CLOTHING', '1811', null, null), ('linshare', 'Shirts and Blouses', 'Sale~~Women~~Shirts ', 'SHIRTS', 'CLOTHING', '1812', null, null), ('linshare', 'Shirts and Blouses', 'Women~~Shirts and Bl', 'SHIRTS', 'CLOTHING', '1813', null, null), ('linshare', 'SHOES', '', 'SHOES', 'SHOES', '1814', null, null), ('linshare', 'Shoes', 'Boots', 'SHOES', 'SHOES', '1815', null, null), ('linshare', 'Shoes', 'Flats', 'SHOES', 'SHOES', '1816', null, null), ('linshare', 'Shoes', 'New and Popular~~New', 'SHOES', 'SHOES', '1817', null, null), ('linshare', 'Shoes', 'New Arrivals', 'SHOES', 'SHOES', '1818', null, null), ('linshare', 'Shoes', 'Oxfords Loafers and ', 'SHOES', 'SHOES', '1819', null, null), ('linshare', 'Shoes', 'Pumps and Slingbacks', 'FLATS', 'SHOES', '1820', null, null), ('linshare', 'Shoes', 'Sandals', 'SANDALS', 'SHOES', '1821', null, null), ('linshare', 'Skirts', 'Sale~~Women~~Skirts', 'SKIRTS', 'CLOTHING', '1822', null, null), ('linshare', 'Skirts', 'UNIQLO UNIQLO~~WOMEN', 'SKIRTS', 'CLOTHING', '1823', null, null), ('linshare', 'Skirts', 'Women~~Skirts', 'SKIRTS', 'CLOTHING', '1824', null, null), ('linshare', 'Tops and T-Shirts', 'Sale~~Women~~Tops an', 'TOPS', 'CLOTHING', '1825', null, null), ('linshare', 'Tops and T-Shirts', 'Women~~Tops and T-Sh', 'TOPS', 'CLOTHING', '1826', null, null), ('linshare', 'Trousers and Jeans', 'Sale~~Women~~Trouser', 'TROUSERS', 'CLOTHING', '1827', null, null), ('linshare', 'Trousers and Jeans', 'Women~~Trousers and ', 'TROUSERS', 'CLOTHING', '1828', null, null), ('linshare', 'WOMANS', 'Bags', 'HANDBAGS', 'ACCESSORIES', '1829', null, null), ('linshare', 'WOMANS', 'Belts', 'BELTS', 'ACCESSORIES', '1830', null, null), ('linshare', 'WOMANS', 'Bracelets', 'JEWELLERY', 'ACCESSORIES', '1831', null, null), ('linshare', 'WOMANS', 'Dresses', 'DRESSES', 'CLOTHING', '1832', null, null), ('linshare', 'WOMANS', 'Earrings', 'JEWELLERY', 'ACCESSORIES', '1833', null, null), ('linshare', 'WOMANS', 'Footwear', 'SHOES', 'SHOES', '1834', null, null), ('linshare', 'WOMANS', 'Jackets', 'COATS & JACKETS', 'CLOTHING', '1835', null, null), ('linshare', 'WOMANS', 'Knitwear', 'KNITWEAR', 'CLOTHING', '1836', null, null), ('linshare', 'WOMANS', 'Necklaces', 'JEWELLERY', 'ACCESSORIES', '1837', null, null), ('linshare', 'WOMANS', 'scarves', 'SCARVES', 'ACCESSORIES', '1838', null, null), ('linshare', 'WOMANS', 'Shirts', 'SHIRTS', 'CLOTHING', '1839', null, null), ('linshare', 'WOMANS', 'Skirts', 'SKIRTS', 'CLOTHING', '1840', null, null), ('affilinet', 'Women > Handbags & purses > Across body bags', 'ProductCategoryName', 'HANDBAGS', 'ACCESSORIES', '1841', null, null), ('affilinet', 'Women > Dresses > Evening & party dresses', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1842', null, null), ('affilinet', 'Women > Trousers & leggings > Smart trousers', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1843', null, null), ('affilinet', 'Women > Trousers & leggings > Petite', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1844', null, null), ('affilinet', 'Women > Trousers & leggings > Cropped trousers', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1845', null, null), ('affilinet', 'Women > Tops > Tops', 'ProductCategoryName', 'TOPS', 'CLOTHING', '1846', null, null), ('affilinet', 'Women > Shoes & boots > Mid heel shoes', 'ProductCategoryName', 'SHOES', 'SHOES', '1847', null, null), ('affilinet', 'Women > Shoes & boots > Knee high boots', 'ProductCategoryName', 'BOOTS', 'SHOES', '1848', null, null), ('affilinet', 'Women > Shoes & boots > High heel shoes', 'ProductCategoryName', 'SHOES', 'SHOES', '1849', null, null), ('affilinet', 'Women > Shoes & boots > Flat shoes', 'ProductCategoryName', 'FLATS', 'SHOES', '1850', null, null), ('affilinet', 'Women > Shoes & boots > Court shoes', 'ProductCategoryName', 'SHOES', 'SHOES', '1851', null, null), ('affilinet', 'Women > Shoes & boots > Calf boots', 'ProductCategoryName', 'BOOTS', 'SHOES', '1852', null, null), ('affilinet', 'Women > Shoes & boots > Ankle boots', 'ProductCategoryName', 'BOOTS', 'SHOES', '1853', null, null), ('affilinet', 'Women > Shirts & blouses > Blouses', 'ProductCategoryName', 'SHIRTS', 'CLOTHING', '1854', null, null), ('affilinet', 'Women > Scarves > Lightweight scarves', 'ProductCategoryName', 'SCARVES', 'ACCESSORIES', '1855', null, null), ('affilinet', 'Women > Jumpers & cardigans > Shrugs & wraps', 'ProductCategoryName', 'SCARVES', 'ACCESSORIES', '1856', null, null), ('affilinet', 'Women > Jumpers & cardigans > Jumpers', 'ProductCategoryName', 'KNITWEAR', 'CLOTHING', '1857', null, null), ('affilinet', 'Women > Jumpers & cardigans > Cardigans', 'ProductCategoryName', 'KNITWEAR', 'CLOTHING', '1858', null, null), ('affilinet', 'Women > Jewellery > Rings', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1859', null, null), ('affilinet', 'Women > Jewellery > Necklaces', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1860', null, null), ('affilinet', 'Women > Jewellery > Matching sets', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1861', null, null), ('affilinet', 'Women > Jewellery > Earrings', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1862', null, null), ('affilinet', 'Women > Jewellery > Brooches', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1863', null, null), ('affilinet', 'Women > Jewellery > Bracelets', 'ProductCategoryName', 'JEWELLERY', 'ACCESSORIES', '1864', null, null), ('affilinet', 'Women > Handbags & purses > Shopper & tote bags', 'ProductCategoryName', 'HANDBAGS', 'ACCESSORIES', '1865', null, null), ('affilinet', 'Women > Handbags & purses > Satchels', 'ProductCategoryName', 'HANDBAGS', 'ACCESSORIES', '1866', null, null), ('affilinet', 'Women > Handbags & purses > Hand held bags', 'ProductCategoryName', 'HANDBAGS', 'ACCESSORIES', '1867', null, null), ('affilinet', 'Women > Dresses > Smart dresses', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1868', null, null), ('affilinet', 'Women > Dresses > Petite', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1869', null, null), ('affilinet', 'Women > Dresses > Day dresses', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1870', null, null), ('affilinet', 'Women > Coats & jackets > Blazers', 'ProductCategoryName', 'BLAZERS', 'CLOTHING', '1871', null, null), ('affilinet', 'Women > Belts', 'ProductCategoryName', 'BELTS', 'ACCESSORIES', '1872', null, null), ('affilinet', 'Women > Coats & jackets > Biker jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1873', null, null), ('affilinet', 'Women > Coats & jackets > Duffle coats', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1874', null, null), ('affilinet', 'Women > Coats & jackets > Faux fur coats', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1875', null, null), ('affilinet', 'Women > Coats & jackets > Leather&#47;leather look jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1876', null, null), ('affilinet', 'Women > Coats & jackets > Lightweight jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1877', null, null), ('affilinet', 'Women > Coats & jackets > Macs & trench coats', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1878', null, null), ('affilinet', 'Women > Coats & jackets > Parka coats', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1879', null, null), ('affilinet', 'Women > Coats & jackets > Winter coats', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1880', null, null), ('affilinet', 'Women > Handbags & purses > Shoulder bags', 'ProductCategoryName', 'HANDBAGS', 'ACCESSORIES', '1881', null, null), ('affilinet', 'Women > Jumpers & cardigans > Jumper dresses', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1882', null, null), ('affilinet', 'Women > Jumpers & cardigans > Polo neck', 'ProductCategoryName', 'KNITWEAR', 'CLOTHING', '1883', null, null), ('affilinet', 'Women > Occasion & evening wear > Skirts', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1884', null, null), ('affilinet', 'Women > Petite > Coats & jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1885', null, null), ('affilinet', 'Women > Petite > Dresses', 'ProductCategoryName', 'DRESSES', 'CLOTHING', '1886', null, null), ('affilinet', 'Women > Petite > Knitwear', 'ProductCategoryName', 'KNITWEAR', 'CLOTHING', '1887', null, null), ('affilinet', 'Women > Petite > Skirts', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1888', null, null), ('affilinet', 'Women > Petite > Trousers & shorts', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1889', null, null), ('affilinet', 'Women > Playsuits & jumpsuits', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1890', null, null), ('affilinet', 'Women > Scarves > Faux fur scarves', 'ProductCategoryName', 'SCARVES', 'ACCESSORIES', '1891', null, null), ('affilinet', 'Women > Shirts & blouses > Shirts', 'ProductCategoryName', 'SHIRTS', 'CLOTHING', '1892', null, null), ('affilinet', 'Women > Skirts > A-line skirts', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1893', null, null), ('affilinet', 'Women > Skirts > Pencil skirts', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1894', null, null), ('affilinet', 'Women > Skirts > Petite', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1895', null, null), ('affilinet', 'Women > Suits & tailoring > Suit trousers', 'ProductCategoryName', 'TROUSERS', 'CLOTHING', '1896', null, null), ('affilinet', 'Women > Tops > Petite', 'ProductCategoryName', 'TOPS', 'CLOTHING', '1897', null, null), ('affilinet', 'Women > Tops > Shirts & blouses', 'ProductCategoryName', 'SHIRTS', 'CLOTHING', '1898', null, null), ('affilinet', 'Women > Tops > Shrugs', 'ProductCategoryName', 'TOPS', 'CLOTHING', '1899', null, null), ('affilinet', 'Women > Jumpers & cardigans > Petite', 'ProductCategoryName', 'KNITWEAR', 'CLOTHING', '1900', null, null), ('affilinet', 'Women > Petite > Tops', 'ProductCategoryName', 'TOPS', 'CLOTHING', '1901', null, null), ('affilinet', 'Women > Coats & jackets > Jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1902', null, null), ('affilinet', 'Women > Suits & tailoring > Suit skirts', 'ProductCategoryName', 'SKIRTS', 'CLOTHING', '1903', null, null), ('affilinet', 'Women > Shoes & boots', 'ProductCategoryName', 'ALL SHOES', 'SHOES', '1904', null, null), ('affilinet', 'Women > Suits & tailoring > Suit jackets', 'ProductCategoryName', 'COATS & JACKETS', 'CLOTHING', '1905', null, null), ('affilinet', 'Women > Petite > Suits & tailoring', 'ProductCategoryName', 'ALL CLOTHING', 'CLOTHING', '1906', null, null), ('awin', 'Bags', 'custom_1', 'HANDBAGS', 'ACCESSORIES', '1907', null, null), ('awin', 'General Clothing', 'custom_1', 'CLOTHING', 'CLOTHING', '1908', null, null), ('awin', 'Women\'s Accessories', 'custom_1', 'ACCESSORIES', 'ACCESSORIES', '1909', null, null), ('awin', 'Women\'s Dresses & Skirts', 'custom_1', 'DRESSES', 'CLOTHING', '1910', null, null), ('awin', 'Women\'s Footwear', 'custom_1', 'SHOES', 'SHOES', '1911', null, null), ('awin', 'Women\'s Jewellery', 'custom_1', 'JEWELLERY', 'ACCESSORIES', '1912', null, null), ('awin', 'Women\'s Outerwear', 'custom_1', 'COATS & JACKETS', 'CLOTHING', '1913', null, null), ('awin', 'Women\'s Suits', 'custom_1', 'BLAZERS', 'CLOTHING', '1914', null, null), ('awin', 'Women\'s Tops', 'custom_1', 'TOPS', 'CLOTHING', '1915', null, null), ('awin', 'Women\'s Trousers', 'custom_1', 'TROUSERS', 'CLOTHING', '1916', null, null), ('awin', 'Women\'s Watches', 'custom_1', 'WATCHES', 'ACCESSORIES', '1917', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
